//package org.pet.mapper;
//
//import org.apache.ibatis.annotations.*;
//import org.pet.entity.PetAdopt;
//import org.pet.util.Result;
//
//import java.util.List;
//
//@Mapper
//public interface PetAdoptMapper {
//    @Select("select owner_id,pet_id,adopt_id,create_time,modify_time from pet_adopt where pet_id = #{petId}")
//    PetAdopt getByPetId(Integer petId);
//
//    @Select({"<script>",
//            "select * from pet_adopt",
//            "<where>",
//            "1=1",
//            "<if test = 'variety != null'>and variety=#{variety}</if>",
//            "<if test = 'gender != null'>and gender=#{gender},</if>",
//            "<if test = 'age != null'>and age=#{age},</if>",
//            "<if test = 'adoptionStatus != null'>and adoption_status=#{adoptionStatus},</if>",
//            "</where>",
//            "</script>"})
//    List<PetAdopt> listPage(String gender, Integer age, String variety, String adoptionStatus);
//
//    @Insert("insert into pet_adopt (owner_id,pet_id,create_time,modify_time) " +
//            "values (#{ownerId},#{petId},#{createTime},#{modifyTime})")
//    int insert(PetAdopt petAdopt);
//
//    @Update("update pet_adopt set adopt_id=#{adoptId} where id=#{id}")
//    int update(PetAdopt petAdopt);
//
//    @Delete("delete from pet_adopt where id=#{id}")
//    int delete(Integer id);
//}
